# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月14日
"""
import openpyxl


myBook =openpyxl.load_workbook('订单表.xlsx',data_only=True)
mySheet1=myBook['已出库订单表']
mySheet2=myBook['未出库订单表']

mySheet3=myBook.copy_worksheet(mySheet1)
mySheet3.title='全部订单表'
while mySheet3.max_row>1:
	mySheet3.delete_rows(2)
myList3=list(mySheet1.values)[1:]
myList2=list(mySheet2.values)[1:]
myList3=myList3+myList2
print(myList3)
myList3=sorted(myList3,key=lambda x:x[1])
print(myList3)
for myRow in myList3:
	mySheet3.append(myRow)
myBook.save('结果表-订单表.xlsx')


